This report reports shows the electricity consumption and amount payable for a typical double storey house in urban city located in Selangor, Malaysia. This report consists of data from year 2014 to date. This report will shows the relation between the consumption and payment for the electricity usage every month and every year.
The details of the house inventory and areas are as describe belows.
| Items | Description | |
|---|---|---|
| 0 | Type | Double Storey Terrace House |
| 1 | Land Area (sq.m) | 121 |
| 2 | Build Up Area (sq.m) | 180 |
| 3 | Bedrooms | 4 |
| 4 | Bathrooms | 3 |
| 5 | Lighting Pts. | 22 |
| 6 | Power Pts. | 14 |
| 7 | Fan Pts. | 4 |
| 8 | AC Pts. | 3 |
| Year | Total Usage (kWh) | Total Amount (RM) | Electricity Rate (RM/kWh) | Ave. Usage (kWh) | Ave. Amount (RM) | Ave. Usage/P (kWh/p) | Ave. Usage/A (kWh/m2) | Max. Usage (kWh) | Max. Amount (RM) |
|---|---|---|---|---|---|---|---|---|---|
| 2014 | 3645 | 964 | 0.26 | 303 | 80 | 60 | 1 | 350 | 102 |
| 2015 | 3569 | 899 | 0.25 | 297 | 74 | 59 | 1 | 405 | 103 |
| 2016 | 4498 | 1365 | 0.30 | 374 | 113 | 74 | 2 | 530 | 188 |
| 2017 | 4719 | 1491 | 0.32 | 393 | 124 | 78 | 2 | 448 | 153 |
| 2018 | 4640 | 1439 | 0.31 | 386 | 119 | 77 | 2 | 490 | 175 |
| 2019 | 4249 | 1278 | 0.30 | 354 | 106 | 70 | 1 | 444 | 151 |
| 2020 | 5080 | 1240 | 0.24 | 423 | 103 | 84 | 2 | 1221 | 164 |
| 2021 | 4596 | 1326 | 0.29 | 383 | 110 | 76 | 2 | 444 | 136 |
| 2022 | 1826 | 524 | 0.29 | 365 | 104 | 30 | 0 | 460 | 152 |
| 2014 | Usage (kWh) | Amount (RM) | kWh/person | |
|---|---|---|---|---|
| 0 | Jan | 261 | 63.98 | 52.2 |
| 1 | Feb | 288 | 70.56 | 57.6 |
| 2 | Mac | 348 | 101.77 | 69.6 |
| 3 | Apr | 263 | 64.64 | 52.6 |
| 4 | May | 350 | 102.80 | 70.0 |
| 5 | Jun | 324 | 89.38 | 64.8 |
| 6 | Jul | 346 | 100.74 | 69.2 |
| 7 | Aug | 268 | 66.31 | 53.6 |
| 8 | Sep | 292 | 74.33 | 58.4 |
| 9 | Oct | 267 | 65.98 | 53.4 |
| 10 | Nov | 301 | 77.52 | 60.2 |
| 11 | Dec | 337 | 86.34 | 67.4 |
| 2015 | Usage (kWh) | Amount (RM) | kWh/person | |
|---|---|---|---|---|
| 0 | Jan | 254 | 61.64 | 50.8 |
| 1 | Feb | 347 | 86.90 | 69.4 |
| 2 | Mac | 276 | 68.98 | 55.2 |
| 3 | Apr | 309 | 81.64 | 61.8 |
| 4 | May | 301 | 77.52 | 60.2 |
| 5 | Jun | 273 | 67.98 | 54.6 |
| 6 | Jul | 405 | 103.84 | 81.0 |
| 7 | Aug | 238 | 56.29 | 47.6 |
| 8 | Sep | 295 | 75.33 | 59.0 |
| 9 | Oct | 266 | 65.64 | 53.2 |
| 10 | Nov | 321 | 81.69 | 64.2 |
| 11 | Dec | 284 | 71.66 | 56.8 |
| 2016 | Usage (kWh) | Amount (RM) | kWh/person | |
|---|---|---|---|---|
| 0 | Jan | 246 | 58.96 | 49.2 |
| 1 | Feb | 399 | 120.01 | 79.8 |
| 2 | Mac | 530 | 188.20 | 106.0 |
| 3 | Apr | 465 | 162.14 | 93.0 |
| 4 | May | 494 | 177.10 | 98.8 |
| 5 | Jun | 342 | 98.67 | 68.4 |
| 6 | Jul | 305 | 79.58 | 61.0 |
| 7 | Aug | 409 | 125.46 | 81.8 |
| 8 | Sep | 336 | 87.80 | 67.2 |
| 9 | Oct | 378 | 117.25 | 75.6 |
| 10 | Nov | 286 | 72.32 | 57.2 |
| 11 | Dec | 308 | 78.16 | 61.6 |
| 2017 | Usage (kWh) | Amount (RM) | kWh/person | |
|---|---|---|---|---|
| 0 | Jan | 427 | 142.53 | 85.4 |
| 1 | Feb | 390 | 123.44 | 78.0 |
| 2 | Mac | 448 | 153.37 | 89.6 |
| 3 | Apr | 441 | 149.76 | 88.2 |
| 4 | May | 361 | 108.48 | 72.2 |
| 5 | Jun | 393 | 124.99 | 78.6 |
| 6 | Jul | 339 | 91.97 | 67.8 |
| 7 | Aug | 383 | 119.83 | 76.6 |
| 8 | Sep | 399 | 122.93 | 79.8 |
| 9 | Oct | 406 | 131.70 | 81.2 |
| 10 | Nov | 405 | 131.18 | 81.0 |
| 11 | Dec | 327 | 90.93 | 65.4 |
| 2018 | Usage (kWh) | Amount (RM) | kWh/person | |
|---|---|---|---|---|
| 0 | Jan | 342 | 98.67 | 68.4 |
| 1 | Feb | 455 | 149.20 | 91.0 |
| 2 | Mac | 426 | 142.02 | 85.2 |
| 3 | Apr | 419 | 138.40 | 83.8 |
| 4 | May | 490 | 175.04 | 98.0 |
| 5 | Jun | 315 | 78.88 | 63.0 |
| 6 | Jul | 357 | 106.41 | 71.4 |
| 7 | Aug | 412 | 134.79 | 82.4 |
| 8 | Sep | 389 | 115.14 | 77.8 |
| 9 | Oct | 358 | 106.93 | 71.6 |
| 10 | Nov | 368 | 112.09 | 73.6 |
| 11 | Dec | 309 | 81.64 | 61.8 |
| 2019 | Usage (kWh) | Amount (RM) | kWh/person | |
|---|---|---|---|---|
| 0 | Jan | 370 | 113.12 | 74.0 |
| 1 | Feb | 444 | 151.30 | 88.8 |
| 2 | Mac | 399 | 130.15 | 79.8 |
| 3 | Apr | 373 | 116.50 | 74.6 |
| 4 | May | 413 | 137.45 | 82.6 |
| 5 | Jun | 285 | 72.00 | 57.0 |
| 6 | Jul | 366 | 112.85 | 73.2 |
| 7 | Aug | 280 | 70.30 | 56.0 |
| 8 | Sep | 348 | 103.40 | 69.6 |
| 9 | Oct | 336 | 97.10 | 67.2 |
| 10 | Nov | 323 | 90.30 | 64.6 |
| 11 | Dec | 312 | 84.50 | 62.4 |
| 2020 | Usage (kWh) | Amount (RM) | kWh/person | |
|---|---|---|---|---|
| 0 | Jan | 355 | 107.05 | 71.0 |
| 1 | Feb | 314 | 85.55 | 62.8 |
| 2 | Mac | 350 | 104.45 | 70.0 |
| 3 | Apr | 350 | 96.35 | 70.0 |
| 4 | May | 350 | 88.80 | 70.0 |
| 5 | Jun | 1221 | 164.40 | 244.2 |
| 6 | Jul | 368 | 112.10 | 73.6 |
| 7 | Aug | 344 | 99.70 | 68.8 |
| 8 | Sep | 360 | 107.96 | 72.0 |
| 9 | Oct | 336 | 82.55 | 67.2 |
| 10 | Nov | 391 | 107.05 | 78.2 |
| 11 | Dec | 341 | 84.80 | 68.2 |
| 2021 | Usage (kWh) | Amount (RM) | kWh/person | |
|---|---|---|---|---|
| 0 | Jan | 322 | 79.55 | 64.4 |
| 1 | Feb | 378 | 111.55 | 75.6 |
| 2 | Mac | 378 | 111.55 | 75.6 |
| 3 | Apr | 361 | 103.00 | 72.2 |
| 4 | May | 357 | 100.95 | 71.4 |
| 5 | Jun | 393 | 119.15 | 78.6 |
| 6 | Jul | 361 | 103.00 | 72.2 |
| 7 | Aug | 436 | 122.28 | 87.2 |
| 8 | Sep | 396 | 108.60 | 79.2 |
| 9 | Oct | 444 | 136.60 | 88.8 |
| 10 | Nov | 404 | 124.65 | 80.8 |
| 11 | Dec | 366 | 105.50 | 73.2 |
| 2022 | Usage (kWh) | Amount (RM) | kWh/person | |
|---|---|---|---|---|
| 0 | Jan | 359.0 | 102.00 | 71.8 |
| 1 | Feb | 323.0 | 83.85 | 64.6 |
| 2 | Mac | 384.0 | 114.60 | 76.8 |
| 3 | Apr | 460.0 | 152.91 | 92.0 |
| 4 | May | 300.0 | 71.00 | 60.0 |
| 5 | Jun | NaN | NaN | NaN |
| 6 | Jul | NaN | NaN | NaN |
| 7 | Aug | NaN | NaN | NaN |
| 8 | Sep | NaN | NaN | NaN |
| 9 | Oct | NaN | NaN | NaN |
| 10 | Nov | NaN | NaN | NaN |
| 11 | Dec | NaN | NaN | NaN |
Note: This report is prepared by Zahiruddin Zahidanishah. This report is only for educational purposed and shall not be used for any commercial purposed.
Note: This report is prepared using open source application such as Jupyter Notebook, Python, Plotly, Pandas and etc.